Referencing the BaseData column

The BaseData column is treated as a part of the period columns in a spreadsheet, even though it is not a true calendar-controlled period. It therefore has a special period index of 0 (zero).

Referencing the BaseData cell in other rows needs the syntax RowCode.0, as the BaseData column is referenced as period number zero (0). For example, EqpHrs.0 will reference the BaseData column in the Equipment Hours row of the current sheet.

The BaseData cell in the current row can be referenced by using the special variable {BaseData}.